SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001235s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019098 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019098 [ RunTime:0.001977s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (595171,869527,694743,879819,205011,973892,383159,665147,894911,239549,781076,319014,332373,465276,416573,1030717,22401,339387,562313,645580,368901,922216,871738,167691,134559,852676,381577,982732,64904,929399,260214,643875,485458,91977,78775,704534,848992,417156,1017623,424827,748464,194379,926616,126824,253715,715951,862621,459488,268088,72848,750852,531609,382704,536983,764302,633918,407322,390821,1030432,693254) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001045s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019098 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000450s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019098 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000675s ]