SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001109s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 842710 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 842710 [ RunTime:0.001684s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (534083,261633,169743,125045,175640,1023957,989003,97181,937621,658602,332970,417676,1030267,455533,313226,334611,253302,68522,827913,261925,921072,149372,773384,177383,796106,699767,850425,850124,902976,1033924,589572,89903,711253,481954,912123,840994,833236,973431,190766,75369,68730,256883,791646,897119,82293,630965,587601,1046511,391857,601986,931728,277004,916899,475704,930082,339775,38203,502749,905597,827603) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001049s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 842710 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000411s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 842710 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000420s ]