SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001044s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040939 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040939 [ RunTime:0.002286s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (351353,459877,437934,577680,575832,291392,595227,64093,375450,841460,335614,79998,145634,459484,977242,181868,629063,165092,226543,753587,763620,723133,352087,703667,434077,308867,685181,554397,387176,745010,947176,598417,460142,345124,602397,78392,382447,431661,886697,602665,235971,180799,788480,966716,953260,602845,934551,502437,178741,35852,406045,650930,495105,42609,414831,837235,509502,91517,838718,300425) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001095s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040939 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000684s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040939 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000512s ]