SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1042986 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1042986 [ RunTime:0.001736s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (536719,690241,427238,611907,462424,762989,545014,83613,787353,789707,83480,198108,755745,1008895,635626,792239,645420,365971,1041410,942289,290696,613840,795865,777195,770364,698472,631941,1024186,874314,79983,878369,628898,617754,844731,246118,101477,905091,951523,12343,945244,399274,445562,732801,376878,323054,609601,140218,431781,512645,933121,893652,54186,67555,189328,10597,223157,1027011,616092,929749,724132) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001064s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1042986 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1042986 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001898s ]