SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003379s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 114710 LIMIT 1 [ RunTime:0.000432s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 114710 [ RunTime:0.002760s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (167042,1033549,1026715,758713,548559,663873,669412,392512,42482,975156,1042543,393666,848509,422593,278846,481808,383696,87816,394852,599299,66691,468825,100751,29893,481198,839242,810117,141496,984425,930597,771076,408530,228711,619411,159511,113171,281510,408297,878441,897583,633042,314024,169547,563461,544235,932612,621286,348722,862973,243846,159895,546504,132470,950479,582914,233491,321199,963528,14404,577243) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003544s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 114710 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 114710 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000697s ]