SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001970s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 529440 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 529440 [ RunTime:0.001831s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (260205,541573,394376,339772,212204,10011,186071,155030,933679,37338,871548,722002,232145,654042,481100,1023571,1016293,1038211,92101,620828,265939,601215,754484,793173,899937,796506,1012114,44059,537143,91377,989974,1013914,682543,730341,399971,400945,122589,462277,979735,1042080,307401,79148,863409,920682,58427,480,36408,376091,951396,135450,742418,749959,39988,797763,736191,438087,562355,719525,628571,439539) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001263s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 529440 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 529440 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000603s ]