SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001121s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 843004 LIMIT 1 [ RunTime:0.000301s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 843004 [ RunTime:0.001549s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (918503,495271,163803,595360,689600,1016781,588323,745567,501806,124410,941240,937525,825385,679152,577277,391954,311532,454197,688441,35992,765269,327580,721075,1026778,478788,846506,968791,1033284,744917,955035,796108,696493,199425,404975,838866,960736,148539,1005454,289358,938818,990985,417676,511160,258465,647884,755684,380976,950700,244888,169115,775015,212962,66236,52488,352431,551429,908983,639609,904516,346394) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 843004 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 843004 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000508s ]