SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001345s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1045210 LIMIT 1 [ RunTime:0.000389s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1045210 [ RunTime:0.003379s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (863819,755708,922041,774531,448521,648018,971924,721926,613487,181568,358455,704561,821844,486358,127560,101233,444360,127239,136940,1030422,802419,396031,112863,536005,107750,663763,11679,407246,256184,110330,280109,344904,621725,1031429,1032707,680339,1032396,838639,263740,544376,1028895,705588,919364,367994,596189,530026,318744,905913,634500,668992,681279,497663,575282,478590,347424,650736,61053,564639,297484,303543) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1045210 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000458s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1045210 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000592s ]