SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 437923 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 437923 [ RunTime:0.001507s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (50572,708050,491999,671878,370932,445228,713941,140113,2003,559532,747055,438328,696305,929736,331892,458112,538322,131509,112405,661693,634606,312371,175113,312742,359405,260401,64677,965335,45426,645091,192709,559803,257287,454634,673836,215315,387510,411734,463937,685273,166802,656693,702222,271797,948507,906256,994495,436009,203199,23085,613402,531448,623566,638256,663967,717638,407328,624402,262694,812176) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001287s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 437923 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000435s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 437923 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000539s ]