SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001260s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503735 LIMIT 1 [ RunTime:0.000394s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503735 [ RunTime:0.002597s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (700554,1002299,258879,58235,223137,150533,586191,564508,493802,565284,502425,1018290,194547,23455,334734,899202,726880,111103,611994,385255,671592,115758,922811,957166,1015865,435689,944597,718926,337961,793081,167356,152453,933746,857671,941535,572891,1013690,46014,473937,451364,670268,960326,33972,709518,957821,400393,908619,481013,127354,1011951,599295,245639,229323,106224,975428,78719,747300,69620,676691,447130) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503735 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000568s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503735 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001103s ]