SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001228s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 827909 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 827909 [ RunTime:0.001626s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (504349,863446,53940,252901,1026599,1010283,916104,646237,415925,46084,90134,616755,342898,426780,202700,1030003,637400,687841,200968,319592,76947,374666,151764,435610,808059,231924,392620,1047754,1007766,413115,1001666,569499,63769,174981,1035137,654177,124049,138658,157958,604699,685705,200851,140423,846482,360224,130739,903307,622094,124604,504918,297508,180846,980383,1011503,820714,465865,530255,260759,107866,673183) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001068s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 827909 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000483s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 827909 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000592s ]