SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001500s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503449 LIMIT 1 [ RunTime:0.000692s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503449 [ RunTime:0.001995s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (642269,562646,752385,286464,640602,342120,945428,1019197,1013210,334799,396922,387525,133300,276451,287906,1042398,941889,378449,779437,245150,863967,765145,732726,182256,813157,667528,367098,183822,1045189,1004579,473563,57021,35965,881204,673986,646333,662662,418039,1045118,14577,1011846,816407,89563,696728,327345,893734,842852,765893,740655,291607,174610,576914,120216,515306,684516,127353,953097,240602,61286,668689) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001255s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503449 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000414s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503449 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000674s ]