SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 436371 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 436371 [ RunTime:0.002348s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (394926,567932,443325,379989,401293,807827,613226,393084,414899,577277,540538,135348,651371,480890,612596,701271,815214,37735,1007114,635586,722030,1035121,72857,434343,310566,186438,596082,720889,205773,692441,874135,274282,328259,116,396264,225885,1043237,774262,676036,283735,566844,272740,251259,590184,822509,437418,741484,935762,511507,250901,607750,109680,665590,938504,25144,1029333,183161,257088,610573,956356) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 436371 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000465s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 436371 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000570s ]