SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001273s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 490834 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 490834 [ RunTime:0.001918s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (115636,78198,314016,238529,95617,807030,463137,176713,287386,198285,625982,128831,872156,1025241,415050,633935,491773,832237,116863,57494,178116,966264,178409,475085,815467,692151,260871,501207,1035333,914748,184446,581953,336438,70709,578688,13848,865829,303473,848668,266369,462899,1005676,1013068,546427,147137,210329,43299,858012,830443,903940,341842,411395,163482,589795,387107,488161,441226,1038719,298846,459291) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001019s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 490834 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 490834 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000509s ]