SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 50893 LIMIT 1 [ RunTime:0.000308s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 50893 [ RunTime:0.001866s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (84638,74429,248518,480973,404030,116299,326916,539333,676583,936168,95952,606821,712444,437436,745389,504102,927535,320037,855092,935632,99301,442303,450514,524495,581839,264544,310901,242122,185182,743606,803815,928274,270082,977829,367480,850952,383103,365739,654224,929429,585289,861819,342122,1006847,688986,291355,634940,923238,600020,747316,35410,422522,629596,427073,486708,282943,504456,494225,116654,287240) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 50893 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 50893 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000590s ]