SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001169s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1002507 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1002507 [ RunTime:0.002074s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (172904,1001429,440413,1007800,921980,541880,636153,180729,615749,429108,990434,364671,689777,467630,814015,497670,586976,378199,1035893,431687,366869,306390,462335,139752,840143,277092,46696,156131,174652,377331,863731,249682,141742,316105,602499,583048,404624,538010,889810,358356,86681,485411,2664,96843,542687,695139,352861,244867,352824,162787,817261,428738,8742,170585,407105,648924,742431,470729,3795,237040) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001280s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1002507 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1002507 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000692s ]