SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001255s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 522718 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 522718 [ RunTime:0.002056s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (516228,764967,496903,973596,441807,309394,453665,672682,356593,741462,483411,431585,625072,300095,135877,129517,575905,177102,532880,355052,386934,751421,99647,6810,831448,843838,231177,1015850,733581,901212,629147,208665,604603,547494,224435,457305,314028,656746,1030729,538350,903446,475687,288595,610740,151184,610546,523749,549473,603184,106983,446593,781572,894077,94765,331827,63711,445013,30314,994923,674646) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001320s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 522718 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000549s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 522718 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000625s ]