SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001439s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 529020 LIMIT 1 [ RunTime:0.000846s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 529020 [ RunTime:0.001908s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (754909,645892,493130,774754,560148,879438,71028,972508,635021,63200,275911,260637,326108,534108,261708,224847,453358,411260,302539,124071,235867,103021,34927,189847,386257,847554,331104,709936,929173,97521,927833,155850,890787,392380,101621,351191,335296,1003143,989896,88947,390567,172961,514892,193320,922852,329526,34729,642122,314959,409127,384723,881614,987413,545082,956816,16061,41700,383055,848142,1022354) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001453s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 529020 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 529020 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000419s ]