SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001910s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1018740 LIMIT 1 [ RunTime:0.000492s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1018740 [ RunTime:0.001471s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (322844,939493,13174,524865,905465,503290,529758,495466,294516,365088,494081,127682,180500,823308,794695,809943,267283,422252,746782,870015,518982,678686,154257,356962,531182,692969,670175,690332,94555,242033,854757,145017,228687,253790,216643,208280,1016437,938485,520577,668430,132776,536839,90509,430711,892061,529625,490597,979997,411374,736840,84119,973780,904231,654735,66736,433230,580022,13731,601231,43237) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1018740 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000416s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1018740 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000601s ]