SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 414401 LIMIT 1 [ RunTime:0.000450s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 414401 [ RunTime:0.002573s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (627521,481731,470878,802217,833112,789405,797225,321813,160087,148579,412464,437233,506569,769060,235174,410457,604393,845961,653870,268364,116679,825437,754888,105212,495338,951894,275386,490707,3106,672753,60600,821267,9248,538330,943924,15867,909234,171612,993647,92667,983874,857572,420593,49106,937502,229604,1047778,120712,844039,971592,1026052,115663,504134,346192,1043316,243797,631127,702872,204445,185135) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001250s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 414401 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000436s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 414401 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000426s ]