SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001299s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 528860 LIMIT 1 [ RunTime:0.000408s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 528860 [ RunTime:0.003113s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (705469,563347,454686,47476,171784,803523,979438,624113,641853,322268,821998,746610,754373,17161,651208,902547,198648,853464,989091,546537,528017,528255,86120,623029,717946,501378,275584,949937,307571,57051,811047,806244,781433,775409,1422,622097,218144,391582,1041932,199591,104801,170730,295024,941604,733939,942874,4535,273736,318338,390817,515170,456272,489945,201723,248355,612432,903844,489148,232616,593467) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001631s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 528860 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 528860 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003988s ]