SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001116s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 822221 LIMIT 1 [ RunTime:0.000420s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 822221 [ RunTime:0.003365s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1022240,562692,179922,213991,784487,640893,363445,80723,1023092,859014,1017162,540520,344840,848930,748275,336181,607364,695402,430332,999857,186204,634571,701574,434933,439161,837498,840382,245849,781803,265408,565354,120763,651579,370225,219797,239788,677441,215115,498477,191571,1006446,336526,267985,31459,255275,337806,891706,148281,633578,845947,1016830,589144,1002688,293860,494706,302858,800488,39938,824733,232847) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002107s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 822221 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001498s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 822221 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000406s ]