SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 444576 LIMIT 1 [ RunTime:0.000344s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 444576 [ RunTime:0.001611s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (499013,781672,606405,849277,508924,379731,84650,788534,9603,362578,916072,625821,907604,192974,668026,440414,769551,352893,554564,543646,774429,10065,707495,462985,294249,1010554,638799,45758,651636,500551,542161,521864,493876,136259,846451,704252,672024,287399,66759,1027791,492055,223423,91230,581329,726582,910095,228956,425152,859679,573169,76680,388017,784723,596513,574478,183317,972898,513167,203675,781554) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001073s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 444576 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 444576 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000624s ]