SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001203s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 310156 LIMIT 1 [ RunTime:0.000416s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 310156 [ RunTime:0.003024s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (597087,1000734,167571,889431,492987,995675,70401,614481,122051,263059,777235,1013717,687606,339546,946776,235029,420354,640373,576537,982697,728724,943543,98830,451117,445391,609663,817905,36868,325214,435480,763928,619920,891721,259261,242019,860202,280228,360102,89851,791449,770281,948856,494676,806309,5439,480996,664544,91294,815250,281838,182381,938703,857543,387321,813928,806710,539704,54444,707678,630912) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001108s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 310156 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000838s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 310156 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000626s ]