SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 80312 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 80312 [ RunTime:0.001759s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (585542,176837,793827,418699,520079,920708,995580,971045,750722,451057,756763,220807,585095,546903,792850,155026,227024,699795,993332,407010,261078,1029973,827211,248513,812697,315868,401999,1023357,583468,927202,11578,945070,405153,103476,928177,802611,375380,387946,159779,854702,651181,232042,1033819,881691,819249,6279,1010632,1036850,678430,1010940,91734,124266,565261,370194,445750,355997,705288,755890,233791,855550) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001250s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 80312 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 80312 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000593s ]