SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001312s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402766 LIMIT 1 [ RunTime:0.000980s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402766 [ RunTime:0.002064s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (871657,333898,551629,743181,506229,978562,667164,863767,927220,870515,597152,62006,907192,681748,801547,163566,224636,740621,978136,659973,250464,564273,403229,771083,833151,583891,37544,545890,757580,32263,500737,14208,589520,913207,438466,485316,578256,381323,244935,740469,562587,724990,26734,131479,922383,146918,185935,640765,994848,41598,623716,696435,731483,843097,6634,1035413,764616,414621,384574,868807) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.030705s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402766 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402766 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002796s ]