SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 53398 LIMIT 1 [ RunTime:0.000282s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 53398 [ RunTime:0.001663s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (738232,865893,739886,223722,1035089,675952,186791,711865,205194,216896,890446,693889,977928,165307,875218,211280,525915,151654,1048488,489401,139658,388887,31909,629972,109339,271354,368658,193444,225085,894976,537378,952974,248105,220663,450081,645541,326555,566775,226736,885933,889014,919686,805298,989685,640287,217446,23657,194872,275408,924198,949969,89938,916988,323674,633284,215881,36280,724310,93918,77024) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001072s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 53398 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000435s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 53398 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000513s ]