SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001401s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019153 LIMIT 1 [ RunTime:0.001445s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019153 [ RunTime:0.002961s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (875675,44110,1027160,1045878,937378,122309,918926,214894,228735,663238,99624,1005424,919795,286550,737551,330906,169940,784053,921960,280811,925151,556693,188647,890657,527738,991517,414787,913250,187033,961624,313362,43024,909536,881608,325481,941641,114156,478901,414725,998690,560634,794400,20940,369470,144793,121181,971909,142352,186317,496713,278941,654236,488363,182946,766034,175401,779865,112787,411012,927225) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001035s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019153 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000327s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019153 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000540s ]