SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001592s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 898528 LIMIT 1 [ RunTime:0.000539s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 898528 [ RunTime:0.002803s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (200948,689368,588870,213668,904329,773082,747397,1041156,723546,557386,485043,46241,1854,839231,305502,328156,862552,344116,20231,273227,924325,364558,751441,655361,624488,1021152,731960,558738,531569,901511,598401,33273,24383,708164,1012264,4955,281778,279330,240518,472261,780029,205520,930713,358425,345324,501706,850057,743186,625318,595525,134000,431659,416080,593099,447178,136865,1016157,349014,1022872,578998) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004062s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 898528 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000429s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 898528 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000640s ]