SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 500080 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 500080 [ RunTime:0.001479s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (784671,1047806,18802,801856,681893,33579,443199,430229,523507,133345,692472,667067,511322,45945,315911,510199,688225,995835,244885,151823,229781,671,508580,482787,706255,493107,243103,25537,495240,689562,774919,673111,843232,1009139,182878,824907,443448,781340,321953,551893,684707,268893,67050,195326,89437,203136,621727,553267,259999,112071,595565,323116,513157,728398,505915,324068,863069,32039,1044723,618406) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001093s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 500080 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000441s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 500080 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000413s ]