SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001273s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 381335 LIMIT 1 [ RunTime:0.001617s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 381335 [ RunTime:0.002556s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (114890,948169,226239,804186,626462,635793,854758,878641,219231,379950,753537,282726,267198,440190,1048013,345860,860886,108521,1020759,346430,289108,340497,235994,788226,14265,103385,147219,295958,355651,1017564,787330,841864,788181,6559,638477,942252,487396,245136,948841,75022,931267,368728,9016,557545,784067,167419,968069,539491,180974,644900,438014,730853,1048412,821015,483685,19292,760173,941712,584232,414929) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001192s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 381335 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000438s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 381335 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000522s ]