SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 471005 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 471005 [ RunTime:0.001443s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (689188,750874,56183,6082,142491,405091,618100,830123,1042005,92044,448690,84390,29738,503305,523935,31611,826571,399283,956625,905269,205492,222965,985661,122327,77456,947813,182096,1008011,881551,450927,455937,581132,1005840,397316,318049,931618,34244,257980,919061,460329,228056,1021644,288459,354383,800959,1044308,658927,488263,617998,378646,202045,776605,496473,937274,324289,430274,896763,927665,513868,117235) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000915s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 471005 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000468s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 471005 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000490s ]