SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 119568 LIMIT 1 [ RunTime:0.000407s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 119568 [ RunTime:0.001965s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (496648,312412,704877,106809,254948,373060,889432,767460,385180,6553,64592,429528,736645,759821,239303,227840,238432,739645,538417,672026,104103,401906,690530,699324,679302,290175,72841,1041656,173414,792313,320843,216605,197344,907879,425776,177011,380163,328307,172401,155617,748232,796877,88355,973926,77057,745418,949429,920744,842528,1000302,719575,698703,296272,812749,815584,598154,577862,874730,729798,790824) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001119s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 119568 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 119568 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000623s ]