SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002084s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 516501 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 516501 [ RunTime:0.002688s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (671186,143526,496139,308215,36251,276155,616063,875229,485428,15557,391777,425822,935091,798137,682155,405396,93905,648481,805614,136627,1042508,346546,551871,703135,479819,911654,820150,41647,704214,942502,356853,598285,887324,739765,1009960,289730,696172,477424,720195,599692,1004671,600751,379920,37562,315570,1039637,726441,52951,577100,173235,752866,129366,63549,66607,523706,538670,185963,731748,701186,362694) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001001s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 516501 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 516501 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000456s ]