SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 489328 LIMIT 1 [ RunTime:0.000432s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 489328 [ RunTime:0.003252s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (448353,413953,1023459,245557,729032,515363,434778,477312,634455,336734,866774,987860,500994,1029084,605687,275804,698388,684117,177947,378319,751092,373439,16964,291882,740963,367648,261348,410431,349148,1029208,994416,680705,600792,193629,620119,605531,212073,670495,75934,891311,783000,729171,125400,33543,25435,309534,636792,93261,2701,271285,42697,467246,591371,755921,474452,352846,739485,503096,228135,121578) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001110s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 489328 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 489328 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000466s ]