SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 537263 LIMIT 1 [ RunTime:0.000383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 537263 [ RunTime:0.001759s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (378561,607018,376578,15597,434218,64943,546373,1036207,129559,939029,582850,413862,511663,514941,893622,963816,134522,164175,854675,23455,251394,204669,588076,962361,107683,255473,675983,20917,312483,123353,33670,673032,763667,977489,61262,792511,913647,160061,130974,365161,149725,846938,1048269,703206,305298,612274,965263,708592,678359,542088,43015,521272,84139,376492,592597,425495,577891,732994,493688,60148) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001001s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 537263 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000628s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 537263 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000331s ]