SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 494813 LIMIT 1 [ RunTime:0.000404s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 494813 [ RunTime:0.001476s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (70565,393834,967728,529087,404290,813114,800329,983739,722152,695947,608781,854701,735114,804043,888517,259181,280911,357511,454223,798642,172347,54351,870465,589106,532027,874326,887828,320419,813798,917708,925093,389142,655007,392287,307095,756236,486308,339515,816787,337004,194801,466507,590529,360089,26274,428569,482017,318312,239949,316507,1008814,882823,113876,980543,128547,272459,427093,346411,205653,22032) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001080s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 494813 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 494813 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000843s ]