SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002060s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 517413 LIMIT 1 [ RunTime:0.000783s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 517413 [ RunTime:0.004675s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (190007,782526,677306,493816,664556,359752,402599,205223,503818,66765,616435,557714,782453,669693,657572,113430,280154,765932,339231,187660,15175,100069,55001,917989,896211,731463,966709,916579,482364,873017,590443,578277,646829,70464,203439,834728,333403,854540,340261,518090,504338,493729,202864,341615,1013427,858560,1014782,427915,355555,312775,43584,456686,905569,1036504,503707,437256,804928,872197,231053,101573) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003688s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 517413 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000517s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 517413 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000644s ]