SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001108s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 472892 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 472892 [ RunTime:0.002158s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (268196,1035653,556987,529482,1013606,252750,845581,776336,701440,624415,869407,625158,1006650,712868,942517,645182,646026,327803,578947,645127,152062,984124,186681,772066,17354,243646,799715,471685,1004059,257675,126828,67506,80159,831053,539177,917219,952188,62355,786390,427093,801122,1015207,871879,131713,803789,587132,165983,651116,222257,264106,897684,322002,76978,927419,488063,576748,438615,431120,174899,496514) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000969s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 472892 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 472892 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000579s ]