SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001256s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 284194 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 284194 [ RunTime:0.004541s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (453148,134771,146566,1002552,497572,120542,890575,520119,952349,176294,82860,128957,714543,909529,693536,886180,602330,700247,1003185,600332,799948,1021663,732895,288038,151668,855374,839012,910070,298277,85097,575671,28752,1040506,851333,228494,567623,41403,347868,80878,533131,979343,726034,655132,491482,1048549,211233,460181,540092,869454,240810,363306,781028,961343,115693,1017657,221584,454476,584585,562843,435673) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001284s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 284194 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000506s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 284194 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000459s ]