SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001250s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 557599 LIMIT 1 [ RunTime:0.000410s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 557599 [ RunTime:0.002132s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (633406,117818,866767,724818,310767,34281,709695,792099,282872,988333,25340,1033653,92622,1013971,493378,644336,423437,341788,564718,429893,258682,410529,957367,445840,416914,229985,908972,565071,943279,229834,295841,267706,271214,697609,81012,99721,230822,676143,606461,871717,839385,232934,514846,1002728,195727,921675,772316,1003240,243217,678563,154530,534205,1033535,55676,1029518,551431,1031584,246000,702062,135772) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001044s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 557599 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 557599 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000506s ]