SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001227s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1030085 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1030085 [ RunTime:0.001748s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (696220,372993,1004239,427052,643553,562755,281144,979952,1010774,16763,471014,213429,154815,645733,545751,896291,431967,700473,610214,44873,340837,771557,1002833,152813,904912,307063,508044,16930,752171,1030119,836758,356724,194958,1009000,715251,48160,726027,734610,484655,485040,321663,603439,859422,924803,342485,34324,450972,1043468,171155,118657,900905,547437,445522,249984,150667,975417,197607,795591,918898,888127) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001023s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1030085 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000336s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1030085 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000949s ]