SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001285s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 40792 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 40792 [ RunTime:0.002318s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (483091,871230,488320,901457,1039832,201159,498784,679552,615717,55247,152047,1010169,840669,717788,335551,218368,207270,487603,240009,20481,822941,259353,883977,163563,897253,678251,753138,735301,872036,57176,597045,706006,388111,853488,703123,257619,710160,788657,498733,41971,4896,922390,898428,603671,314359,727357,518266,915264,607373,711687,221259,51371,863775,1013711,495654,858116,585758,543837,291797,88089) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001056s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 40792 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 40792 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000431s ]