SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001331s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 496916 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 496916 [ RunTime:0.001686s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (103814,631071,143793,595558,326277,603123,391750,798435,401816,423797,391679,699902,993003,718668,333032,1035459,4980,170527,583197,771472,957425,509456,224448,506949,881394,235674,981508,329378,149027,920190,824134,156129,209265,930430,975058,288802,339087,658378,434099,469997,163387,664029,909905,687959,731236,779224,60958,2927,1041247,139110,266766,614882,834506,2474,866029,379622,643856,922933,11596,932267) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001119s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 496916 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 496916 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000448s ]