SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001128s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 104781 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 104781 [ RunTime:0.001869s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (972540,226596,93298,438983,486371,138105,247035,277795,275584,911904,942001,768861,9493,309595,638531,453671,114015,658954,337073,248537,199034,291211,1035748,998820,141264,455231,986119,291981,345868,533327,287078,823552,358985,502788,530944,800833,621502,238353,432519,317245,796903,475557,618286,1032359,1014485,44872,764256,90245,126457,711680,254503,18815,83151,1029581,172122,250685,265062,576853,351152,220007) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001037s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 104781 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 104781 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000567s ]