SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 801669 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 801669 [ RunTime:0.001722s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1043895,402416,75482,186373,15230,798574,206806,767353,1004473,470803,160300,296426,634104,877264,207761,68659,1045701,232958,141133,109524,947554,311502,398636,224517,71430,759234,686793,172999,292344,340064,177795,244776,571384,809035,167922,660229,674164,205571,383380,732350,71342,755701,860877,103050,980476,65015,363173,457002,994917,1011939,1020114,453422,266185,489366,871616,830684,588456,492514,237288,400728) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001236s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 801669 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 801669 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000544s ]