SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001183s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 576480 LIMIT 1 [ RunTime:0.000396s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 576480 [ RunTime:0.004557s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (897060,952188,670533,648051,962273,123396,170279,506652,241295,201814,768878,916828,367845,1044614,32466,143057,230976,590794,462352,735857,227496,430086,823117,632951,463934,42867,827306,122680,821866,538136,297758,235542,973800,784653,329357,214217,318885,562055,862093,354437,393842,172964,910946,372795,925288,834757,141165,172201,347502,172153,661819,960205,229561,168907,759423,657656,24709,624991,971262,841771) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001325s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 576480 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 576480 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000598s ]