SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 450783 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 450783 [ RunTime:0.003028s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (939207,907553,785736,952244,1027279,47604,872749,805996,551234,480719,839601,523605,801290,719827,479538,875394,576447,320330,420578,349380,24410,343616,762411,914212,58805,512100,631448,422897,653020,729844,884172,623325,429808,1002201,1047750,230762,368059,38663,635101,756947,107472,357524,998571,268198,309022,138102,13275,178557,399461,19687,729139,614495,153336,648624,351437,505917,316250,787754,221514,701968) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001292s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 450783 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 450783 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000693s ]