SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001109s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 102040 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 102040 [ RunTime:0.002234s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (314115,437049,455119,526976,903595,136841,409497,550760,207677,676333,187911,987783,956016,215829,790349,723692,806966,789955,792971,46621,468362,95812,709956,997113,205462,839810,595226,717987,927642,899123,859934,141972,196569,273804,591669,855432,132248,714673,35861,898351,600308,209644,103052,508674,84331,167919,513605,670157,902661,223323,608170,465379,620087,704754,461149,400662,166944,104296,557915,12453) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000997s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 102040 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000431s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 102040 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000542s ]