SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002847s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 610505 LIMIT 1 [ RunTime:0.000833s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 610505 [ RunTime:0.003615s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (988180,208033,146520,250906,968284,1033115,640097,196897,896849,961941,929116,826767,465177,781096,329481,341597,402839,519401,911214,534266,361532,468106,841669,211511,51536,540226,272585,804733,451653,576022,134753,203257,11532,536844,792681,750761,549179,570646,503231,354433,382587,358531,804161,180099,297959,966167,610023,346956,88482,340418,499811,1037633,281061,569467,306459,352316,295455,478409,722064,105102) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001063s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 610505 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 610505 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000566s ]