SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001863s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 135003 LIMIT 1 [ RunTime:0.000735s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 135003 [ RunTime:0.005965s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1030231,355170,1002783,846482,712949,657532,888047,115484,91336,194020,331318,196402,1032545,151577,412233,580168,101003,439098,401787,459973,763638,309768,989535,276892,499647,1017412,435741,756819,359417,39347,917233,42314,650399,317251,73930,111427,101174,658651,253710,498260,601072,1002084,275254,77343,717078,60526,709399,962429,213224,364195,716815,43764,1007731,81354,440332,930394,967172,818278,113292,56121) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 135003 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000443s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 135003 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002458s ]