SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001247s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 711978 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 711978 [ RunTime:0.001746s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (619321,859616,5231,481960,478772,182640,59117,430270,700784,767888,401358,1020940,595408,234363,507488,534651,352975,748972,1007155,936169,875099,1007290,586975,438524,1039955,600255,238136,270646,647075,1048184,404302,1025087,1003959,167974,344778,237946,887253,885082,623819,10984,819792,139166,599162,897504,353697,449916,787540,625677,592667,1031437,469238,593049,945901,5105,610414,69430,646139,778580,247624,536338) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001330s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 711978 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 711978 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000584s ]