SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 195580 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 195580 [ RunTime:0.002213s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (866721,120731,424638,33268,871556,139687,917113,635748,982299,412928,123330,946331,781637,804918,769522,137220,219541,266726,64867,562584,349695,147569,1009597,678030,476548,658828,791138,38714,357022,468534,710564,666210,174405,149647,619778,202890,407083,204201,893280,370163,97736,771550,651292,794132,645636,79845,1035663,1011944,747488,558020,487961,191330,108983,56840,425331,1030579,436522,496249,928814,209803) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001001s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 195580 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 195580 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000544s ]