SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 559419 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 559419 [ RunTime:0.001500s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (965072,932200,470483,7701,118664,134512,421480,439716,260165,144628,943202,443431,671091,921213,387544,157493,801164,765665,483860,573606,303926,253849,399234,516073,405654,799611,652352,577882,392273,915099,556313,171237,1019346,253799,659742,738560,426544,880928,811654,335321,836050,700614,932731,63557,676671,984852,140210,772026,692096,485482,955368,145029,66206,911087,703981,186526,1041150,306794,626747,98470) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001045s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 559419 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 559419 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000556s ]