SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004832s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 318104 LIMIT 1 [ RunTime:0.000704s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 318104 [ RunTime:0.003187s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (806106,279208,253217,387049,647285,158898,42068,820459,409618,92086,867654,466984,214407,797163,793544,853918,114840,827916,45856,636101,852324,114316,259320,744847,662652,56271,915185,231485,210437,525054,9327,602632,565836,763315,155222,750569,813618,550626,215799,428261,356640,396111,838270,165950,918051,1033377,469165,331940,692959,834326,403835,915364,476749,1038257,554969,604458,613994,610879,961475,54577) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004664s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 318104 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000499s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 318104 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000556s ]