SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001384s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020834 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020834 [ RunTime:0.002220s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (300732,162017,358086,503653,99488,370466,185460,474024,534392,46384,810538,892526,410730,30020,924248,276847,499497,411106,806313,624087,105226,697716,913136,445867,1022416,275889,819501,557673,727323,685111,1048511,107473,536124,549987,404391,944153,816898,297350,950028,571064,248551,818491,426714,579390,40123,495357,873706,851781,243425,888629,275455,653150,858478,687874,62194,568240,240339,295141,897372,1041733) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.010961s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020834 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000639s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020834 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000477s ]